<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.0 Transitional//EN'><html>
<head>
<title>Database documentation</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF8"/>
<style type='text/css'>
	 #dbs {font-family:Tahoma,Dialog,Sans-Serif;font-size:11px;background:#fff;width:80%;border-collapse:collapse;text-align:left;margin:20px;}
	 #dbs thead{background:#ddd;}
	 #dbs th{font-size:12px;font-weight:bold;color:#336;border-bottom:2px solid #336;padding:7px 8px;}
	 #dbs td{border-bottom:1px solid #ccc;color:#336;padding:3px 8px;white-space: pre;}
	 td.subpart{font-weight:bold;background:#ddd}
	 td.name{background:#f2f2f2}
	 #dbs tbody tr:hover td{color:#000;background:#fffcea;}
</style>
</head>

<body>
<object data='ghfhghg.svg' width='3192' height='6882' type='image/svg+xml' >
<embed src='ghfhghg.svg' width='3192' height='6882' type='image/svg+xml' />
<p>The <a href="http://www.adobe.com/svg/viewer/install/main.html">Adobe SVG Viewer</a> is required to view this image !</p></object>
<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='batch_details'>batch_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_name'>batch&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_date'>start&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_date'>end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_count'>student&#095;count</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='incharge_id'>incharge&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;college&#095;batch primary key</td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='college_residential'>college_residential</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='residential_id'>residential&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='residential_name'>residential&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='residential_type'>residential&#095;type</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='warden_id'>warden&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='warden_name'>warden&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='capacity'>capacity</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;college&#095;residential primary key</td>
		<td> ( residential&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='college_staff'>college_staff</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='staff_id'>staff&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='staff_name'>staff&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='designation'>designation</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='joining_date'>joining&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='phone_number'>phone&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='address_line'>address&#095;line</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='city'>city</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='state'>state</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='country'>country</a></td>
		<td width='40%'> VARCHAR&#040; 30 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='email_id'>email&#095;id</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='staff_type'>staff&#095;type</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='role'>role</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;college&#095;staff primary key</td>
		<td> ( staff&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='college_staff_financial'>college_staff_financial</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='staff_id'>staff&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='salary_amount'>salary&#095;amount</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='salary_date'>salary&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='payment_made'>payment&#095;made</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year'>year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='month'>month</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;college&#095;staff&#095;financial </td>
		<td> ( staff&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_college_staff_financial</td>
		<td > (  staff&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='connections'>connections</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='user_connection_id'>user&#095;connection&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='user_id'>user&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='connection_id'>connection&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='connection_start_date'>connection&#095;start&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='connection_type'>connection&#095;type</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;student&#095;connections primary key</td>
		<td> ( user&#095;connection&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;connections </td>
		<td> ( user&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_connections_user_id_type_1</td>
		<td > (  user&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_connections_connection_id_type_1</td>
		<td > (  user&#095;connection&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_connections_user_id_type_2</td>
		<td > (  user&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_connections_connection_id_type_2</td>
		<td > (  connection&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='course_details'>course_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_name'>course&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='duration'>duration</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='credit'>credit</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='lab'>lab</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='theory'>theory</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='department_id'>department&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;course&#095;details primary key</td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;details </td>
		<td> ( department&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_course_details</td>
		<td > (  department&#095;id  ) ref <a href='#department&#095;details'>department&#095;details</a> ( department&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='course_management'>course_management</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='capacity'>capacity</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_date'>start&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_date'>end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='prerequisite'>prerequisite</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='total_exams'>total&#095;exams</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;course&#095;management </td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;management </td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_course_management_course_id</td>
		<td > (  course&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_management_batch_id</td>
		<td > (  batch&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='course_professor'>course_professor</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='course_professor_id'>course&#095;professor&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id_1'>professor&#095;id&#095;1</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id_2'>professor&#095;id&#095;2</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id_3'>professor&#095;id&#095;3</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id_4'>professor&#095;id&#095;4</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_date'>start&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_date'>end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='lecture_duration'>lecture&#095;duration</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='status'>status</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='visiting_id'>visiting&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;course&#095;professor primary key</td>
		<td> ( course&#095;professor&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( professor&#095;id&#095;1) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( professor&#095;id&#095;2) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( professor&#095;id&#095;3) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( professor&#095;id&#095;4) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;course&#095;professor </td>
		<td> ( visiting&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_course_professor_course_id</td>
		<td > (  course&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_professor_id_1</td>
		<td > (  professor&#095;id&#095;1  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_professor_id_2</td>
		<td > (  professor&#095;id&#095;2  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_professor_id_3</td>
		<td > (  professor&#095;id&#095;3  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_professor_id_4</td>
		<td > (  professor&#095;id&#095;4  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_course_professor_visiting_id</td>
		<td > (  visiting&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_course'>degree_course</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_course_id'>degree&#095;course&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='mandatory'>mandatory</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;degree&#095;course primary key</td>
		<td> ( degree&#095;course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;course </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;course </td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_degree_course_year_semester_id</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_degree_course_id</td>
		<td > (  course&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_current_year_semester'>degree_current_year_semester</a></th></tr>
<tr><td colspan='3'>this will point to any semester of any batch for any degree under any department&#046; this will be useful at several places&#046; 
for eg&#046; you can find out&#058;
1&#046; what courses were offered on 3rd semester of 2004 batch for B&#046;Tech degree under DB department </td></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_department_id'>degree&#095;department&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year'>year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='semester'>semester</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;degree&#095;current&#095;year&#095;semester primary key</td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;current&#095;year&#095;semester </td>
		<td> ( degree&#095;department&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_degree_current_year_semester_degree_department_id</td>
		<td > (  degree&#095;department&#095;id  ) ref <a href='#degree&#095;department'>degree&#095;department</a> ( degree&#095;department&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_department'>degree_department</a></th></tr>
<tr><td colspan='3'>contains the mapping of department &#045; degree &#045; batch&#046; this can be used for the following for example&#058; 
1&#046; finding which departments are there in M&#046;Tech degree of 2010 batch&#046; 
2&#046; finding the degrees offered in 2011 batch of IT department
3&#046; finding the batches enrolled for B&#046;Tech degree of CS department </td></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_department_id'>degree&#095;department&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='department_id'>department&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_id'>degree&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;degree&#095;department primary key</td>
		<td> ( degree&#095;department&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;department </td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;department </td>
		<td> ( department&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;department </td>
		<td> ( degree&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_degree_department_batch_id</td>
		<td > (  batch&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_degree_department_department_id</td>
		<td > (  department&#095;id  ) ref <a href='#department&#095;details'>department&#095;details</a> ( department&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_degree_department_degree_id</td>
		<td > (  degree&#095;id  ) ref <a href='#degree&#095;details'>degree&#095;details</a> ( degree&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_details'>degree_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_id'>degree&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_name'>degree&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='duration'>duration</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='prerequisite'>prerequisite</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_update_date'>last&#095;update&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;degree&#095;details primary key</td>
		<td> ( degree&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='degree_management'>degree_management</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='degree_id'>degree&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_incharge_id'>degree&#095;incharge&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='incharge_start_date'>incharge&#095;start&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='incharge_end_date'>incharge&#095;end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;degree&#095;management </td>
		<td> ( degree&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;degree&#095;management </td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_degree_management_degree_id</td>
		<td > (  degree&#095;id  ) ref <a href='#degree&#095;details'>degree&#095;details</a> ( degree&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_degree_management_batch_id</td>
		<td > (  batch&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='department_details'>department_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='department_id'>department&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='department_name'>department&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;department&#095;details primary key</td>
		<td> ( department&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='document_upload'>document_upload</a></th></tr>
<tr><td colspan='3'>this will map all the documents uploaded with the uploader id&#046; for example&#044;
if a student uploads a document in DB course&#044; then that document entry will
first be stored in this table&#044; then it will be used everywhere using this document&#095;id </td></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='document_id'>document&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='uploader_id'>uploader&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='document_name'>document&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='upload_date'>upload&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;document&#095;upload primary key</td>
		<td> ( document&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;document&#095;upload </td>
		<td> ( uploader&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_document_upload_uploader_id_type_1</td>
		<td > (  uploader&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_document_upload_uploader_id_type_2</td>
		<td > (  uploader&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='follow'>follow</a></th></tr>
<tr><td colspan='3'>this is a generic table&#046; this will contain who is following what&#046; thus a follower can be any student or staff &#040;professor 
and non&#045;teaching staff&#041; and he&#047;she can be following anything&#058; colleges&#044; courses&#044; departments&#044; batches&#044; etc&#046; </td></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='follow_id'>follow&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='follower_id'>follower&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='following_id'>following&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='follow_start_date'>follow&#095;start&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;follow primary key</td>
		<td> ( follow&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;follow </td>
		<td> ( follower&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;follow </td>
		<td> ( following&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_follow_follower_id_type_1</td>
		<td > (  follower&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_1</td>
		<td > (  following&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_2</td>
		<td > (  following&#095;id  ) ref <a href='#department&#095;details'>department&#095;details</a> ( department&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_folllowing_id_type_3</td>
		<td > (  following&#095;id  ) ref <a href='#degree&#095;details'>degree&#095;details</a> ( degree&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_4</td>
		<td > (  following&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_5</td>
		<td > (  following&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_following_id_type_6</td>
		<td > (  following&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_follow_college_staff</td>
		<td > (  follower&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='group'>group</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='group_id'>group&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='group_name'>group&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='owner_id'>owner&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='create_date'>create&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_update_date'>last&#095;update&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='capacity'>capacity</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;group primary key</td>
		<td> ( group&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group </td>
		<td> ( owner&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_group_owner_id_type_1</td>
		<td > (  owner&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_owner_id_type_2</td>
		<td > (  owner&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='group_member'>group_member</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='group_id'>group&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='member_id'>member&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='add_date'>add&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='leave_date'>leave&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_update)date'>last&#095;update&#041;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='added_by_id'>added&#095;by&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;group&#095;member unique</td>
		<td> ( group&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group&#095;member </td>
		<td> ( member&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group&#095;member </td>
		<td> ( added&#095;by&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_group_member_group</td>
		<td > (  group&#095;id  ) ref <a href='#group'>group</a> ( group&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_member_member_id_type_1</td>
		<td > (  member&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_member_member_id_type_2</td>
		<td > (  member&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_member_added_by_id_type_1</td>
		<td > (  added&#095;by&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_member_added_by_id_type_2</td>
		<td > (  added&#095;by&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='group_update'>group_update</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='group_id'>group&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='update_id'>update&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='member_id'>member&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='parent_update_id'>parent&#095;update&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='document_id'>document&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;group&#095;update </td>
		<td> ( group&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group&#095;update </td>
		<td> ( member&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;group&#095;update </td>
		<td> ( document&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_group_update_group_id</td>
		<td > (  group&#095;id  ) ref <a href='#group'>group</a> ( group&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_update_member_id</td>
		<td > (  member&#095;id  ) ref <a href='#group&#095;member'>group&#095;member</a> ( group&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_group_update_document_id</td>
		<td > (  document&#095;id  ) ref <a href='#document&#095;upload'>document&#095;upload</a> ( document&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='library_book_details'>library_book_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='book_id'>book&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='author_name'>author&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='book_name'>book&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='category'>category</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='price'>price</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='publisher'>publisher</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='referred_by'>referred&#095;by</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;library&#095;book&#095;details primary key</td>
		<td> ( book&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='login_info'>login_info</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='login_id'>login&#095;id</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='password'>password</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='college_id'>college&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_login_time'>last&#095;login&#095;time</a></td>
		<td width='40%'> TIMESTAMP     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='last_password_update_time'>last&#095;password&#095;update&#095;time</a></td>
		<td width='40%'> TIMESTAMP     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='security_question'>security&#095;question</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='security_question_answer'>security&#095;question&#095;answer</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='user_type'>user&#095;type</a></td>
		<td width='40%'> VARCHAR&#040; 30 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;login&#095;info </td>
		<td> ( login&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_login_info_student_details</td>
		<td > (  login&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( email&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='message'>message</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='message_id'>message&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='sender_id'>sender&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='receiver_id'>receiver&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='body'>body</a></td>
		<td width='40%'> VARCHAR&#040; 5000 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='subject'>subject</a></td>
		<td width='40%'> VARCHAR&#040; 1000 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='attachment_id'>attachment&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;message primary key</td>
		<td> ( message&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;message </td>
		<td> ( sender&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;message </td>
		<td> ( receiver&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;message </td>
		<td> ( attachment&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_message_sender_id_type_1</td>
		<td > (  sender&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_message_sender_id_type_2</td>
		<td > (  sender&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_message_receiver_id_type_1</td>
		<td > (  receiver&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_message__receiver_id_type_2</td>
		<td > (  receiver&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_message_attachment_id</td>
		<td > (  attachment&#095;id  ) ref <a href='#document&#095;upload'>document&#095;upload</a> ( document&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='placements'>placements</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='company_id'>company&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='company_name'>company&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='visit_date'>visit&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='visit_time'>visit&#095;time</a></td>
		<td width='40%'> TIME     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='internship'>internship</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='regular'>regular</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='package_offered'>package&#095;offered</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='job_description'>job&#095;description</a></td>
		<td width='40%'> VARCHAR&#040; 1000 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_placed_count'>student&#095;placed&#095;count</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;placements primary key</td>
		<td> ( company&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;placements </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_placements_student_batch</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='posts'>posts</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='post_id'>post&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='posted_by_id'>posted&#095;by&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='post date'>post date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='post_content'>post&#095;content</a></td>
		<td width='40%'> VARCHAR&#040; 1000 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;posts primary key</td>
		<td> ( post&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;posts </td>
		<td> ( posted&#095;by&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_posts_posted_by_id_type_1</td>
		<td > (  posted&#095;by&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_posts_posted_by_id_type_2</td>
		<td > (  posted&#095;by&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='professor_department'>professor_department</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='professor_id'>professor&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='department_id'>department&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='position'>position</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='role'>role</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;professor&#095;details </td>
		<td> ( professor&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;professor&#095;details </td>
		<td> ( department&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_professor_details_professor_id</td>
		<td > (  professor&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_professor_details</td>
		<td > (  department&#095;id  ) ref <a href='#department&#095;details'>department&#095;details</a> ( department&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='professor_work'>professor_work</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='professor_id'>professor&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_id'>course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='patent'>patent</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='research'>research</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='project'>project</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_date'>start&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_date'>end&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;professor&#095;work </td>
		<td> ( professor&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;professor&#095;work </td>
		<td> ( course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;professor&#095;work </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_professor_work_professor_id</td>
		<td > (  professor&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_professor_work_course_id</td>
		<td > (  course&#095;id  ) ref <a href='#course&#095;details'>course&#095;details</a> ( course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_professor_work</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='residential_room'>residential_room</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='room_id'>room&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='residential_id'>residential&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='room_number'>room&#095;number</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='vacancy'>vacancy</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='occupancy'>occupancy</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;residential&#095;room </td>
		<td> ( residential&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;residential&#095;room primary key</td>
		<td> ( room&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_residential_room_residential_id</td>
		<td > (  residential&#095;id  ) ref <a href='#college&#095;residential'>college&#095;residential</a> ( residential&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_batch'>student_batch</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_id'>student&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='batch_id'>batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_department_id'>degree&#095;department&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='start_year'>start&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='end_year'>end&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='room_id'>room&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;batch </td>
		<td> ( batch&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;batch </td>
		<td> ( student&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;batch </td>
		<td> ( degree&#095;department&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;student&#095;batch primary key</td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;batch&#095;0 </td>
		<td> ( room&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_batch_batch_id</td>
		<td > (  batch&#095;id  ) ref <a href='#batch&#095;details'>batch&#095;details</a> ( batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_batch_student_id</td>
		<td > (  student&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( student&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_batch_department_degree_id</td>
		<td > (  degree&#095;department&#095;id  ) ref <a href='#degree&#095;department'>degree&#095;department</a> ( degree&#095;department&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_batch_room_id</td>
		<td > (  room&#095;id  ) ref <a href='#residential&#095;room'>residential&#095;room</a> ( room&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_book_borrow'>student_book_borrow</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='borrower_id'>borrower&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='book_id'>book&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='issue_date'>issue&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='return_date'>return&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='borrower_type'>borrower&#095;type</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='fine'>fine</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;book&#095;borrow </td>
		<td> ( book&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;book&#095;borrow </td>
		<td> ( borrower&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_book_borrow_book_id</td>
		<td > (  book&#095;id  ) ref <a href='#library&#095;book&#095;details'>library&#095;book&#095;details</a> ( book&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_book_borrow_borrower_id</td>
		<td > (  borrower&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( student&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_course'>student_course</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_course_id'>student&#095;course&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_id'>student&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='degree_course_id'>degree&#095;course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='marks'>marks</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='grade'>grade</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;course </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course </td>
		<td> ( degree&#095;course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course&#095;0 </td>
		<td> ( student&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;student&#095;course primary key</td>
		<td> ( student&#095;course&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_course_year_semester_id</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_course_degree_course_id</td>
		<td > (  degree&#095;course&#095;id  ) ref <a href='#degree&#095;course'>degree&#095;course</a> ( degree&#095;course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_course_student_id</td>
		<td > (  student&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( student&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_course_project'>student_course_project</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='course_project_id'>course&#095;project&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_project_name'>course&#095;project&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_course_id'>student&#095;course&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='abstract'>abstract</a></td>
		<td width='40%'> VARCHAR&#040; 500 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='professor_id'>professor&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='recognition'>recognition</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='technology_used'>technology&#095;used</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='skill_used'>skill&#095;used</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;student&#095;course&#095;project primary key</td>
		<td> ( course&#095;project&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course&#095;project </td>
		<td> ( student&#095;course&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course&#095;project&#095;0 </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;course&#095;project&#095;1 </td>
		<td> ( professor&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_course_project_student_course_id</td>
		<td > (  student&#095;course&#095;id  ) ref <a href='#student&#095;course'>student&#095;course</a> ( student&#095;course&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_course_project</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_course_project_professor_id</td>
		<td > (  professor&#095;id  ) ref <a href='#college&#095;staff'>college&#095;staff</a> ( staff&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_details'>student_details</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_id'>student&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_name'>student&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='roll_number'>roll&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='registration_number'>registration&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='mobile_number'>mobile&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='phone_number'>phone&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='address_line_1'>address&#095;line&#095;1</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='address_line_2'>address&#095;line&#095;2</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='city'>city</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='state'>state</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='country'>country</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='email_id'>email&#095;id</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='date_of_birth'>date&#095;of&#095;birth</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='highest_degree'>highest&#095;degree</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='highest_degree_marks'>highest&#095;degree&#095;marks</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='highest_degree_college_name'>highest&#095;degree&#095;college&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='highest_degree_passout_year'>highest&#095;degree&#095;passout&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_1'>previous&#095;degree&#095;1</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_1_marks'>previous&#095;degree&#095;1&#095;marks</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_1_college_name'>previous&#095;degree&#095;1&#095;college&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_1_passout_year'>previous&#095;degree&#095;1&#095;passout&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_2'>previous&#095;degree&#095;2</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_2_marks'>previous&#095;degree&#095;2&#095;marks</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_2_college_name'>previous&#095;degree&#095;2&#095;college&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='previous_degree_2_passout_year'>previous&#095;degree&#095;2&#095;passout&#095;year</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='years_of_experience'>years&#095;of&#095;experience</a></td>
		<td width='40%'> FLOAT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='gender'>gender</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='father_name'>father&#095;name</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='pan_card_number'>pan&#095;card&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='passport_number'>passport&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='passport_expiry_date'>passport&#095;expiry&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;student&#095;details primary key</td>
		<td> ( student&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;student&#095;details&#095;0 unique</td>
		<td> ( email&#095;id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_finance_one_time'>student_finance_one_time</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='caution_fee'>caution&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='admission_fee'>admission&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='other_fee'>other&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='total_payment'>total&#095;payment</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='fine'>fine</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;finance&#095;one&#095;time </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_finance_one_time_student_batch_id</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_financial_semester_wise'>student_financial_semester_wise</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='tuition_fee'>tuition&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='library_fee'>library&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='hostel_fee'>hostel&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='mess_fee'>mess&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='other_fee'>other&#095;fee</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='total_payment'>total&#095;payment</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='payment_date'>payment&#095;date</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='receipt_number'>receipt&#095;number</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='fine'>fine</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;financial&#095;semester&#095;wise </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;financial&#095;semester&#095;wise </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_financial_semester_wise_student_batch_id</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_financial_semester_wise_year_semester_id</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_placed'>student_placed</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='company_id'>company&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='internship'>internship</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='regular'>regular</a></td>
		<td width='40%'> BOOL     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;placed </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_placed_company__id</td>
		<td > (  company&#095;id  ) ref <a href='#placements'>placements</a> ( company&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_placed_student_batch_id</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_profile_picture'>student_profile_picture</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='user_id'>user&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='profile_picture'>profile&#095;picture</a></td>
		<td width='40%'> BLOB     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;profile&#095;picture </td>
		<td> ( user&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_profile_picture_user_id</td>
		<td > (  user&#095;id  ) ref <a href='#student&#095;details'>student&#095;details</a> ( student&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_result'>student_result</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='student_id'>student&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='year_semester_id'>year&#095;semester&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='course_professor_id'>course&#095;professor&#095;id</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='final_grade'>final&#095;grade</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='attendance'>attendance</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='theory_grade'>theory&#095;grade</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='practical_grade'>practical&#095;grade</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='result'>result</a></td>
		<td width='40%'> VARCHAR&#040; 20 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='description'>description</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;student&#095;result </td>
		<td> ( student&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;result </td>
		<td> ( year&#095;semester&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;result </td>
		<td> ( course&#095;professor&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_result_student_id</td>
		<td > (  student&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_result_year_semester_id</td>
		<td > (  year&#095;semester&#095;id  ) ref <a href='#degree&#095;current&#095;year&#095;semester'>degree&#095;current&#095;year&#095;semester</a> ( year&#095;semester&#095;id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_student_result_course_professor_id</td>
		<td > (  course&#095;professor&#095;id  ) ref <a href='#course&#095;professor'>course&#095;professor</a> ( course&#095;professor&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='student_resume'>student_resume</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='resume_id'>resume&#095;id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='student_batch_id'>student&#095;batch&#095;id</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='title'>title</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='url'>url</a></td>
		<td width='40%'> VARCHAR&#040; 200 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='most_recent'>most&#095;recent</a></td>
		<td width='40%'> BOOL    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='upload_date'>upload&#095;date</a></td>
		<td width='40%'> DATE    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;student&#095;resume primary key</td>
		<td> ( resume&#095;id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;student&#095;resume </td>
		<td> ( student&#095;batch&#095;id) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_student_resume_student_batch_id</td>
		<td > (  student&#095;batch&#095;id  ) ref <a href='#student&#095;batch'>student&#095;batch</a> ( student&#095;batch&#095;id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

</body></html>